How to use the create/offline/drop/rename method of datafile

This article mainly introduces "how to use the create/offline/drop/rename method of datafile". In the daily operation, I believe that many people use the create/offline/drop/rename of datafile.

2022-05-31 Database 我要分享

Pt-online-change-ddl (online ddl)

Mysql > desc online_ddl;+-+-+ |

2022-06-01 Database 我要分享

Recovery of physically deleted oracle data files

Test in archive mode: (normal file system): physically delete data files in open, restore if not closed: SQL > select file_name from dba_data_files;FILE_NAME-

2022-06-01 Database 我要分享

How to recover the inconsistent data files in the database

Editor to share with you how to restore data file inconsistencies in the database, I believe most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article. Let's go and learn about it! Restore data file cannot recove

2022-05-31 Database 我要分享

ORACLE11GR2 RAC file system changed to ASM EXTEND RAC and high availability test

There has always been the idea of playing with ASM EXTEND RAC, suffering from the lack of resources to test, and so on. God lives up to the thoughtful man ~ ! Finally have the resources to play. 2 sets of storage: EMS and HDS, respectively in different computer rooms. Because the original test system uses a file system

2022-06-01 Database 我要分享

What if oracle rac creates datafile to the local file system and causes orastar-20170924 errors?

This article mainly introduces what to do when oracle rac creates datafile to the local file system resulting in orastar-20170924 errors. The article is very detailed and has certain reference value. Interested friends must finish reading it! 1. Problem description

2022-05-31 Database 我要分享

How to use the switch command in RMAN

This article is about how to use the switch command in RMAN. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look. SWITCH command details Purpose: purpose, even if you can do it with the switch command

2022-05-31 Database 我要分享

Data files are not recognized / locked by ORA-01157 and ORA-01110

The same error was reported in production before. The user queried the data in the client table and reported the following error: Errors in file / oratrace/xxx/diag/rdbms/xxx/xxx2/trace/xxx2_dbw0_845

2022-06-01 Database 我要分享

Project practice: search for comparative testing tools

Search for comparison testing tool catalog 1. Introduction to the tool. 12. Design ideas. 13. The utility of the tool. 34. Tool integration extension. 61. Tool introduction: due to the company's search service and underlying index creation and maintenance, maintenance by colleagues in the infrastructure department, business access

2022-06-03 Internet Technology 我要分享

A brief introduction to the related knowledge of MySQL5.7 online DDL

This article mainly introduces MySQL5.7 online DDL related knowledge, the content of the article is carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand the MySQL5.7 online DDL related knowledge. 1 、 M

2022-06-01 Database 我要分享

KVM (2) KVM applications: expand capacity online, increase the number of CPU cores online, increase memory online, and create restore snapshots of KVM virtual machines

Qemu-img snapshot is commonly used in + + creating and taking snapshots + + KVM snapshots

2022-06-01 Network Security 我要分享

Installation Oracle11gR2 RAC One Node-Test 2

6.3. after the restart test restarts Node 2, check the status in Node 1. At this time, the instance is ORACLE_2 and runs on Node 2. Grid@node1:~ > crsctl stat res-t-

2022-06-01 Database 我要分享

MySQL modifies the table structure pt-osc online

MySQL modify the table structure online pt-osc it is well known that the DDL operation of MySQL is relatively expensive. Because MySQL blocks any read and write operations during table modification. Basically, business is paralyzed. If the amount of data is large, it may take several hours to complete, none

2022-06-01 Database 我要分享

What are the common operations of Oracle11g RAC maintenance and management

This article is to share with you about the common operations of Oracle11g RAC maintenance and management, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. 1. View

2022-06-01 Servers 我要分享

Installation of oracle12C databases for ProxmoxVE (CDB and PDB)

On the left above is my personal Wechat. For further communication, please add Wechat. On the right is my official account "Openstack Private Cloud". If you are interested, please follow us. The RAC environment of oracle12C was built on the PVE environment two days ago (for details, see another blog post, "Prox."

2022-06-01 Database 我要分享

On the difference between online and offline performance test results

Many friends often struggle with the difference between online and offline test results. So it's better to write such an article together, in fact, there is no need to struggle with this problem itself, just like no matter how powerful the twins are, there are still differences between them. Performance testing itself is a way to estimate risks and troubleshoot bottlenecks.

2022-06-03 Internet Technology 我要分享

What is the backup and restore of DM7 database and its tables

DM7 database and its table backup and restore is how, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something. Main tests of DM7 online backup recovery: 1. No

2022-05-31 Database 我要分享

CREATE INDEX .ONLINE example analysis

Today, I will talk to you about the example analysis of CREATE INDEX. Online. many people may not understand it very well. in order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article. Let's discuss it here.

2022-06-01 Servers 我要分享

How to modify the field length of a table online with pt-online-schema-change

Pt-online-schema-change dependency condition: the table of operation must have a primary key, otherwise the error experiment will be performed as follows: MySQL [mysql] > create database chenfeng;Query OK

2022-06-01 Database 我要分享

How to use shell script to batch test whether the LAN host is online

This article mainly explains "how to use shell script to test whether the LAN host is online or not." interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to use shell script to test local area network owners in batches."

2022-06-03 Development 我要分享